Check if General Ledger Account Number is unique

To proceed with this check execute the following queries according to your database type: Access database: Select * from [GLAccount] where[Number] in (Select [Number] from [GLAccount] Group by [Number] having count(*) > >1) order by [Number], [Id] SQL Server database: Select * from [GLAccount] where convert(varchar, [DBId]) + ‘-‘ + [Number] in (Select convert(varchar, [DBId]) … Continue reading Check if General Ledger Account Number is unique